FREE Delivery, NO minimum for Groceries Purchased at COSTCO BUSINESS CENTRE
Mysql Error: SELECT p.id, p.title, c.title, cp.title,
MATCH (c.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)/LENGTH(c.title) as c0,
MATCH (c.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)/LENGTH(c.title) as c1,
MATCH (cp.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)/LENGTH(cp.title) as cp0,
MATCH (cp.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)/LENGTH(cp.title) as cp1,
MATCH (p.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)/LENGTH(p.title) as score0,
MATCH (p.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)/LENGTH(p.title) as score01,
(
MATCH (p.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) +
MATCH (p.description) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) +
MATCH (p.keywords) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) +
MATCH (k.keyword) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)
) as score1,
MATCH (p.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) as score2,
MATCH (p.description) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) as score3,
MATCH (p.keywords) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) as score4,
MATCH (k.keyword) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) as score5
FROM `products` p, `keywords` k, `product_keywords` pk, `categories` c, `categories` cp WHERE cp.id = c.parent_id AND p.category = c.id AND pk.product_id = p.id AND k.id = pk.keyword_id AND p.deleted = 0 AND p.removed = 0 AND c.hidden = 0 AND c.deleted = 0 AND
(
MATCH (p.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)
OR
MATCH (p.description) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)
OR
MATCH (p.keywords) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)
OR
MATCH (k.keyword) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)
OR
(MATCH (c.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) AND c.title NOT LIKE '%&%' AND c.title NOT LIKE '% and %')
)
GROUP BY p.id HAVING ((c0+c1) > 0 AND c.title NOT LIKE '%&%' AND c.title NOT LIKE '% and %') or ((cp0+cp1) > 0 AND cp.title NOT LIKE '%&%' AND cp.title NOT LIKE ' and ') OR score0 > 0 OR score1 > 0 ! syntax error, unexpected '+' Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /var/www/clients/client5/web59/web/classes/_database.php on line 37
Mysql Error: SELECT p.id, p.title, c.title, cp.title,
MATCH (c.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)/LENGTH(c.title) as c0,
MATCH (c.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)/LENGTH(c.title) as c1,
MATCH (cp.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)/LENGTH(cp.title) as cp0,
MATCH (cp.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)/LENGTH(cp.title) as cp1,
MATCH (p.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)/LENGTH(p.title) as score0,
MATCH (p.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)/LENGTH(p.title) as score01,
(
MATCH (p.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) +
MATCH (p.description) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) +
MATCH (p.keywords) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) +
MATCH (k.keyword) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)
) as score1,
MATCH (p.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) as score2,
MATCH (p.description) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) as score3,
MATCH (p.keywords) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) as score4,
MATCH (k.keyword) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) as score5
FROM `products` p, `keywords` k, `product_keywords` pk, `categories` c, `categories` cp WHERE cp.id = c.parent_id AND p.category = c.id AND pk.product_id = p.id AND k.id = pk.keyword_id AND p.deleted = 0 AND p.removed = 0 AND c.hidden = 0 AND c.deleted = 0 AND
(
MATCH (p.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)
OR
MATCH (p.description) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)
OR
MATCH (p.keywords) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)
OR
MATCH (k.keyword) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE)
OR
(MATCH (c.title) AGAINST ('(+ + + +suggestionkeyword + + +)' IN BOOLEAN MODE) AND c.title NOT LIKE '%&%' AND c.title NOT LIKE '% and %')
)
GROUP BY p.id ORDER BY cp0 DESC, cp1 DESC, c0 DESC, c1 DESC, score0 DESC, score01 DESC, score1 DESC, score2 DESC, score3 DESC, score4 DESC, score5 DESC! syntax error, unexpected '+' Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /var/www/clients/client5/web59/web/classes/_database.php on line 32
CREATE A BUSINESS ACCOUNT Exclusive benefits especially designed for all your business needs
LOGIN WITH YOUR CELL PHONE#
YOUR VALIDATION CODE
SET DELIVERY ADDRESS
SELECT RESTAURANT
About Us
COSTCO BUSINESS CENTRE, DELIVERED
We bring Costco Business Centre value to your door. You'll find thousands of products that are not available at traditional Costco locations.
Our specialized in-store shoppers and our chauffeurs will handle your products with care and with your safety in mind. Innovative packaging and high-performance insulated containers maintain the quality of your products while on delivery. Proprietary technology predicts the time you can receive the order before you even place it. A truly seamless experience.
Zum Zum is an independent delivery service and is not affiliated with or endorsed by Costco Business Centre.
Why and how we started
Zum Zum is owned & operated by Rosedale Livery which was founded in 1981 by Douglas McCutcheon with a clear commitment to customer service. Today, Rosedale Livery is the largest operator of livery limousines in Canada and through investments in people and technology, continues to change and adapt to the evolving needs of the clients.
We started as a new division meant to create more value for our existing customers and answer to their immediate needs. Because of the COVID-19 pandemic, more and more people demanded help with groceries delivery.
Combining Rosedale Livery entire experience, software and delivery infrastructure with wholesale stores high quality and exclusive products, we are on a mission to make this great value more accessible to as many people and businesses as possible.
Refunds and cancellations are subject to certain conditions. Please read carefully to understand our policies.
Refunds
To request a refund due to order issues, you must make your request within 7 days of delivery. Simply, reply to the order confirmation email and let us know if your order:
* is missing items that you were charged for on the final receipt;
* contains damaged, spoiled, or otherwise unusable items.
You can ask for your refund in the form of Zum Zum credit, which can be issued immediately. Zum Zum credits will automatically apply during checkout on your next order.
Additionally, you can request for credit card refund. Please note it may take 5-10 business days to see the funds in your bank or credit card account, depending on your bank.
Returns
Due to COVID, we DO NOT accept the returns of the items.
Cancelling an order
Simply, reply to the order confirmation email and let us know if you want to cancel your order. You can cancel an order for a full refund without any additional fees before a shopper begins shopping.